SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_FacultyActivities_UpdateVerifyState]
	(
		@param_JOL_FacultyActivities_ID Int ,
		@param_JOL_FacultyActivities_VerifyState NVarChar(10) ,
		@param_JOL_FacultyActivities_VerifyUser NVarChar(50) ,
		@param_JOL_FacultyActivities_VerifyTime DateTime
	)
AS
	UPDATE dbo.JOL_FacultyActivities
	SET JOL_FacultyActivities_VerifyState = @param_JOL_FacultyActivities_VerifyState,
		JOL_FacultyActivities_VerifyUser = @param_JOL_FacultyActivities_VerifyUser,
		JOL_FacultyActivities_VerifyTime = @param_JOL_FacultyActivities_VerifyTime
	WHERE JOL_FacultyActivities_ID = @param_JOL_FacultyActivities_ID	
GO
